********************************************************************************
******     Table A8 Logged Nominal FXR and Nonimal + Real (RER)            *****
********************************************************************************

use "voting exchange rate data 15 July 2023.dta", clear 
////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////
xtset ifscode year

**Variable Labeling**
label var cap100 "Capital"
label var cur100 "Current"
label var underval "Exchange Rate Undervaluation"
label var wbcode "World Bank Country Code"
label var underval91 "Exchange Rate Unvervaluation_91"
label var lgrow9 "Log Growth"
label var balance9 "Trade/GDP Trade Balance"
label var popgr9 "Population Growth (mean)"
label var trade_gdp "Trade/GDP"
label var inflation "Inflation (mean)" 
label var unemployment_ilo_est "Unemployment ILO Estimate (mean)"
label var unemployment_nat_est "Unemployment National Estimate (mean)"
label var cap100 "Capital Account"
label var fh_civ "Civil Liberties Rating (Freedom House)"
label var fh_pol "Political Rights Rating"
label var lvau "De Jure and De Facto Central Bank Independence Index unweighted"
label var lvaw "De Jure and De Facto Central Bank Independence Index weighted"
label var oil_rents "Oil Rents"
label var polcomp "Political Competition (mean)"
label var resource_rents "Resource Rents"
label var pr "Proportional Representation"
label var EU "European Union membership"
label var year "Year"
label var banking_center "Banking Center"
label var monetary_union "Monetary Union"
label var lgrow9 "Log Growth"
label var lnrealgdp9 "Log Income PC"
label var polity2 "Polity 2"
label var balance9 "Trade Balance/GDP"
label var exchangerateregime_fine "Exchange Rate Regime Rheinart and Rogoff (Fine classification)"
label var peg "Standard Shambaugh 2004 classification (1= peg,0= nonpeg) (Shambaugh)"
label var ifscode "International Financial Statistics Database Country Code"
label var ifs "International Financial Statistics Database Country"
label var polcomp "Political Competition Concept"
label var ltrade9 "Log Trade Openess (mean)"
label var cowcode "Country Codes according to the Correlates of War Project"
label var oecd "OECD membership"
label var GEO "Continent"
label var polity4 "Polity 4"
label var exchangerateregime_coarse "Exchange Rate Regime (Coarse Classification)"
label var unemploymerge "Unemployment Merge"
label var linvest9 "Log Investment"
label var linflation "Lag Inflation"
label var l2underval "Lag 2 Undervaluation"
label var l2underval91 "Lag 2 Undervaluation91"
label var Inct2019 "Incumbent Vote Share"
label var Inct12019 "Incumbent Vote Share 1"
label var Inct22019 "Incumbent Vote Share 2"
label var l2undervalreg91 "Lag_2 Exchange Rate Undervaluation"

gen dlnxr =lnxr-lnxr[_n-1]
gen l2lnxr=lnxr[_n-2]

xtset ifscode year, delta(1)

////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////
******     Table A8 Logged Nominal FXR and Nonimal + Real (RER)            *****
////////////////////////////////////////////////////////////////////////////////

eststo clear

*1
eststo: xtreg dInct2019 i.year    c.l.dlnxr##c.l2.lnxr l.peg_no_euro l.lgrow9 l.balance9 l.trade_gdp l.inflation l.unemploymerge  l.euro maj_01 if banking_center!=1 & polity>6 & year>1973, fe vce(cluster ifscode)
tabstat dlnxr if e(sample), s(min max mean p50 sd)
tabstat lnxr if e(sample), s(min max mean p50 sd)

margins, dydx(l.dlnxr ) at(l2.lnxr =(-13(1) 10)  )
marginsplot, title("Estimated Effect of FXR Currency Depreciation t-1 on Incumbent Vote Share") ytitle("Avg Marginal Effect of ΔεXRi,t-1 on Vote Shares") xtitle("Nominal FXR Valuation (logged) at t-2 (negative values equal overvaluation)") yline(0) recastci(rline) recast(line)  legend(off) addplot( hist l2lnxr if e(sample) , width(1) percent mfcolor(none) fcolor(none) lcolor(gs10) yaxis(2) yscale(alt axis(2)))


*2
eststo: xtreg dInct2019 i.year    c.l.dlnxr##c.l2.lnxr c.l.d.underval91##c.l2.underval91 l.peg_no_euro l.lgrow9 l.balance9 l.trade_gdp l.inflation l.unemploymerge  l.euro maj_01 if banking_center!=1 & polity>6 & year>1973, fe vce(cluster ifscode)


margins, dydx(l.d.underval91 ) at(l2.underval91 =(-1.2(.1) .7)  )
marginsplot, title("Estimated Effect of Currency Depreciation t-1 on Incumbent Vote Share") ytitle("Avg Marginal Effect of ΔεXRi,t-1 on Vote Shares") xtitle("RER Valuation (εXRi) at t-2 (negative values equal overvaluation)") yline(0) recastci(rline) recast(line)  legend(off) addplot( hist l2underval91 if e(sample) , width(.05) percent mfcolor(none) fcolor(none) lcolor(gs10) yaxis(2) yscale(alt axis(2)))



esttab * using Table_A8.csv,  label b(3) se(3) scalar(r2_w r2_b r2_o N_clust) sfmt( a3 a0) star(* 0.1 ** 0.05 *** 0.01) replace  parentheses
eststo clear 
